CREATE external TABLE IF NOT EXISTS jms_dm.dm_problem_record_keywords_detail_dt (
    waybill_no                   STRING comment '运单'
    ,reply_network_code          STRING comment '回复网点code'
    ,reply_network_name          STRING comment '回复网点名称'
    ,reply_time                  STRING comment '回复时间'
    ,registration_network_name   STRING comment '登记网点code'
    ,registration_network_code   STRING comment '登记网点名称'
    ,registration_time           STRING comment '登记时间'
    ,message_keywords            STRING comment '消息关键词'
)
comment '拦截退转-问题件关键词'
PARTITIONED BY (dt STRING comment '分区日期yyyy-mm-dd')
stored as parquet
location '/dw/hive/jms_dm.db/external/dm_problem_record_keywords_detail_dt'
;